<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;

class CreateGrinfosTable extends Migration {

	/**
	 * Run the migrations.
	 *
	 * @return void
	 */
	public function up()
	{
		Schema::create('grinfos', function(Blueprint $table)
		{
			$table->increments('id');
			$table->string('gongr_name');
			$table->string('canp_name')->nullable();
			$table->string('gongx_name')->nullable();
			$table->string('chej_name')->nullable();
			$table->integer('yue')->nullable();
			$table->integer('day1')->nullable();
			$table->integer('day2')->nullable();
			$table->integer('day3')->nullable();
			$table->integer('day4')->nullable();
			$table->integer('day5')->nullable();
			$table->integer('day6')->nullable();
			$table->integer('day7')->nullable();
			$table->integer('day8')->nullable();
			$table->integer('day9')->nullable();
			$table->integer('day10')->nullable();
			$table->integer('day11')->nullable();
			$table->integer('day12')->nullable();
			$table->integer('day13')->nullable();
			$table->integer('day14')->nullable();
			$table->integer('day15')->nullable();
			$table->integer('day16')->nullable();
			$table->integer('day17')->nullable();
			$table->integer('day18')->nullable();
			$table->integer('day19')->nullable();
			$table->integer('day20')->nullable();
			$table->integer('day21')->nullable();
			$table->integer('day22')->nullable();
			$table->integer('day23')->nullable();
			$table->integer('day24')->nullable();
			$table->integer('day25')->nullable();
			$table->integer('day26')->nullable();
			$table->integer('day27')->nullable();
			$table->integer('day28')->nullable();
			$table->integer('day29')->nullable();
			$table->integer('day30')->nullable();
			$table->integer('day31')->nullable();
			$table->timestamps();
		});
	}


	/**
	 * Reverse the migrations.
	 *
	 * @return void
	 */
	public function down()
	{
		Schema::drop('grinfos');
	}

}
